<?php
/*
  $Id$

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2010 osCommerce

  Released under the GNU General Public License
*/

  require('includes/application_top.php');

  require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_REVIEWS);

  $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_REVIEWS));

  require(DIR_WS_INCLUDES . 'template_top.php');
?>

<div class="middle-area">
  <div class="innermidbox fl">
    <div class="innermidbox-top"></div>
    <div class="innermidbox-mid">
      <div class="pdt5 pdl20 pdr20 pdb5 minheight527px">
        <div class="breadcrumbs"><a href="index.php">Home</a> > <span><?php echo HEADING_TITLE; ?></span></div>
        <div class="spacer10"></div>
        <div class="">
          <h1 class="pagetitle"><?php echo HEADING_TITLE; ?></h1>
          <div class="hline"></div>
          <div class="spacer3"></div>
          <!--left panel start-->
          <?php include('includes/template_left.php'); ?>
          <!--left panel end-->
          <!--right panel start-->
          <div class="rightpanel mgl15 fl">
            <!--listing start-->
            <?php
				$reviews_query_raw = "select r.reviews_id, left(rd.reviews_text, 100) as reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, r.customers_name from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and rd.languages_id = '" . (int)$languages_id . "' and reviews_status = 1 order by r.reviews_id DESC";
  
				$reviews_split = new splitPageResults($reviews_query_raw, MAX_DISPLAY_NEW_REVIEWS);

				if(($reviews_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3'))) 
				{
			?>
            <div class="pagingbox">
              <div class="pdl10 pdt5 pdb5 pdr10">
                <div class="fl"><?php echo $reviews_split->display_count(TEXT_DISPLAY_NUMBER_OF_REVIEWS); ?></div>
                <div class="fr">
                  <div class="paging "> <?php echo $reviews_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info'))); ?> </div>
                </div>
                <div class="clear"></div>
              </div>
            </div>
            <!--paging end-->
            <div class="spacer10"></div>
            <?php
  				}
			?>
            <?php
  				if($reviews_split->number_of_rows > 0) 
  				{
					$reviews_query = tep_db_query($reviews_split->sql_query);
    				while($reviews = tep_db_fetch_array($reviews_query))
					{
?>
            <div class="cms">
            	
              	<h2><a href="<?=tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO,'products_id='.$reviews['products_id'].'&reviews_id='.$reviews['reviews_id'])?>" title="<?=$reviews['products_name']?>" ><?=$reviews['products_name']?></a>
                <span style="font-size:18px;"><?=sprintf(TEXT_REVIEW_BY, tep_output_string_protected($reviews['customers_name']))?></span>
                </h2>
            </div>
            
            <div class="reviewbox mgt10 mgr10 mgb10">
              	<a href="<?=tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO,'products_id='.$reviews['products_id'].'&reviews_id='.$reviews['reviews_id'])?>" ><?=tep_image(DIR_WS_IMAGES.$reviews['products_image'],$reviews['products_name'],SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)?></a>
                
                <div class="fr">
                	<?php echo tep_break_string(tep_output_string_protected($reviews['reviews_text']),800, '-<br/>').((strlen($reviews['reviews_text'])>=800)? '..' : ''). '<br /><br /><i>' . sprintf(TEXT_REVIEW_RATING, tep_image(DIR_WS_IMAGES . 'stars_' . $reviews['reviews_rating'] . '.gif', sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])), sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])) . '</i>'; ?>
                  
                  <div class="w100pr mgauto mgr5 mgb5">
                  <?php
				  	for($i=0;$i<5;$i++)
					{
						if($i<$reviews['reviews_rating'])
						{
                  ?>
                  		<span class="red-star-rate"></span>
                  <?php
						}
						else
						{
                  ?>
                  		<span class="grey-star-rate"></span>
                  <?php
						}
					}
                  ?>
                  <span style="float: right;"><?php echo sprintf(TEXT_REVIEW_DATE_ADDED, tep_date_long($reviews['date_added'])); ?></span>
                  </div>
                  
                  </td>
                </tr>
              </table>
            </div>
            </div>
            <div class="spacer10"></div>
            <?php		
    				}
  				}
				else 
				{
			?>
            <?php echo TEXT_NO_REVIEWS; ?>
            <?php
  				}
			?>
            <?php
				if(($reviews_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3'))) 
				{
			?>
            <div class="spacer10"></div>
            <div class="pagingbox">
              <div class="pdl10 pdt5 pdb5 pdr10">
                <div class="fl"><?php echo $reviews_split->display_count(TEXT_DISPLAY_NUMBER_OF_REVIEWS); ?></div>
                <div class="fr">
                  <div class="paging "> <?php echo $reviews_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info'))); ?> </div>
                </div>
                <div class="clear"></div>
              </div>
            </div>
            <!--paging end-->
            <?php
  				}
			?>
            <!--listing end-->
          </div>
          <!--right panel end-->
          <div class="spacer10"></div>
        </div>
      </div>
    </div>
    <div class="innermidbox-bottom"></div>
  </div>
</div>
<!--middle area end-->
<div class="spacer25"></div>
</div>
<?php
  require(DIR_WS_INCLUDES . 'template_bottom.php');
  require(DIR_WS_INCLUDES . 'application_bottom.php');
?>